Name |
|
Code |
|
Comment |
|
Name |
Code |
Name |
Code |
Parent Table |
Child Table |
Foreign Key Columns |
Parent Role |
Child Role |
TemplateTypeID |
|
|
||||
LanguageID |
|
|
||||
ReasonID |
|
|
||||
FrequencyID |
|
|
||||
TimeTemplateID |
|
|
||||
PersonnelTypeID |
|
|
||||
SchedulerID |
|
|
||||
FrequencyID |
|
|
||||
FrequencyID |
|
|
||||
LanguageID |
|
|
||||
DayID |
|
|
||||
TemplateDayID |
|
|
||||
TimeSlotID |
|
|
||||
TemplateTimeSlotID |
|
|
||||
VisitTypeID |
|
|
||||
VisitTypeID |
|
|
||||
VisitID |
|
|
||||
TimeSlotID |
|
|
||||
MedResourceID |
|
|
||||
MedResourceID |
|
|
||||
VisitTypeID |
|
|
||||
HolidayID |
|
|
||||
FrequencyID |
|
|
||||
HolidayID |
|
|
||||
MedResourceID |
|
|
||||
TimeslotTypeID |
|
|
||||
TimeslotTypeID |
|
|
||||
LanguageID |
|
|
||||
TimeslotTypeID |
|
|
||||
TimeSlotStatusID |
|
|
||||
TimeSlotStatusID |
|
|
||||
LanguageID |
|
|
||||
PersonnelTypeID |
|
|
||||
TimeSlotMetaTypeID |
|
|
||||
TimeSlotMetaTypeID |
|
|
||||
LanguageID |
|
|
||||
LPersonnelTypeID |
|
|
||||
ReasonID |
|
|
||||
LanguageID |
|
|
||||
Tim_TimeSlotID |
|
|
||||
TimeSlotID |
|
|
||||
VisitID |
|
|
||||
JobTimeID |
|
|
||||
MedResourceID |
|
|
||||
JobID |
|
|
||||
LPersonnelTypeID |
|
|
||||
JobID |
|
|
||||
LanguageID |
|
|
||||
ReasonTypeID |
|
|
||||
ReasonTypeID |
|
|
|
|
|